package com.yyc.system.dao;

import java.util.List;

import org.apache.ibatis.annotations.Select;

import com.yyc.core.Mapper;
import com.yyc.system.model.TGrade;

public interface TGradeMapper extends Mapper<TGrade> {

	@Select("SELECT a.*,b.user_name FROM t_grade a JOIN t_user b ON a.user_id = b.id WHERE a.class_id = #{classId} ORDER BY a.total DESC")
	List<TGrade> getClassGrade(Integer classId);
}